﻿<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="EA_TRU.ascx.cs" Inherits="StreetSmartAdmin.EA_TRU" %>
<h2>EA TRU Form</h2> 
            


            <asp:DetailsView ID="DetailsView3" runat="Server" CellPadding="4" ForeColor="#333333"
                        GridLines="None" DataSourceID="SqlDataSource4" AllowPaging="True" AutoGenerateRows="False"
                        DataKeyNames="ID" AutoGenerateInsertButton="True" DefaultMode="Edit" CssClass="mGrid"
                        PagerStyle-CssClass="pgr" AlternatingRowStyle-CssClass="alt" 
                            EnableModelValidation="True">
                        <AlternatingRowStyle CssClass="alt"></AlternatingRowStyle>
                        <Fields>


                            <asp:TemplateField HeaderText="ID" InsertVisible="False" SortExpression="ID">
                                <ItemTemplate>
                                    <asp:Label ID="Label70" runat="server" Text='<%# Bind("ID") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:Label ID="Label1" runat="server" Text='<%# Eval("ID") %>'></asp:Label>
                                </EditItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="USERID" SortExpression="USERID">
                                <ItemTemplate>
                                    <asp:Label ID="Label1" runat="server" Text='<%# Bind("USERID") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:Label ID="lblUSERID" runat="server" Text='<%# Bind("USERID") %>'></asp:Label>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("USERID") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Fuel Type" SortExpression="FUEL_TYPE">
                                <ItemTemplate>
                                    <asp:Label ID="Label2" runat="server" Text='<%# Bind("FUEL_TYPE") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>

                                       <asp:DropDownList ID="SelFuelType" runat="server" 
                                            SelectedValue='<%# Bind("FUEL_TYPE") %>'>
                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem Value="ELEC_ONLY">Electricity Only</asp:ListItem>
                                            <asp:ListItem Value="GAS_ONLY">Gas Only</asp:ListItem>
                                            <asp:ListItem Value="DUAL_FUEL">Dual Fuel</asp:ListItem>
                                        </asp:DropDownList>
                                        <asp:RequiredFieldValidator ID="SelFuelTypeVali" runat="server" 
                                            ControlToValidate="SelFuelType" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>

                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("FUEL_TYPE") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Discount Type" SortExpression="DISCOUNT_TYPE">
                                <ItemTemplate>
                                    <asp:Label ID="Label3" runat="server" Text='<%# Bind("DISCOUNT_TYPE") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                       <asp:DropDownList ID="SelDISCOUNT_TYPE" runat="server" 
                                            SelectedValue='<%# Bind("DISCOUNT_TYPE") %>'>
                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem Value="UO">Usage Only</asp:ListItem>
                                            <asp:ListItem Value="US">Usage Only and Supply</asp:ListItem>
                                        </asp:DropDownList>
                                        <asp:RequiredFieldValidator ID="SelDISCOUNT_TYPEVali" runat="server" 
                                            ControlToValidate="SelDISCOUNT_TYPE" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>

                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("DISCOUNT_TYPE") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Customer Type" SortExpression="CUSTOMER_TYPE">
                                <ItemTemplate>
                                    <asp:Label ID="Label4" runat="server" Text='<%# Bind("CUSTOMER_TYPE") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                        <asp:DropDownList ID="SelCUSTOMER_TYPE" runat="server" 
                                            SelectedValue='<%# Bind("CUSTOMER_TYPE") %>'>
                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem Value="SME">SME</asp:ListItem>
                                            <asp:ListItem Value="RESD">RESD</asp:ListItem>
                                        </asp:DropDownList>
                                        <asp:RequiredFieldValidator ID="SelCUSTOMER_TYPEVali" runat="server" 
                                            ControlToValidate="SelCUSTOMER_TYPE" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
 
                               </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("CUSTOMER_TYPE") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Contract Duration" 
                                SortExpression="CONTRACT_DURATION">
                                <ItemTemplate>
                                    <asp:Label ID="Label5" runat="server" Text='<%# Bind("CONTRACT_DURATION") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="CONTRACT_DURATION" runat="server" 
                                        Text='<%# Bind("CONTRACT_DURATION") %>'></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="CONTRACT_DURATIONVali" runat="server" 
                                            ControlToValidate="CONTRACT_DURATION" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
 

                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox5" runat="server" 
                                        Text='<%# Bind("CONTRACT_DURATION") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Electricity Network Area" 
                                SortExpression="ELEC_NETWORK_AREA">
                                <ItemTemplate>
                                    <asp:Label ID="Label6" runat="server" Text='<%# Bind("ELEC_NETWORK_AREA") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>

                                    <asp:DropDownList ID="SelELEC_NETWORK_AREA" runat="server" SelectedValue='<%# Bind("ELEC_NETWORK_AREA") %>'>
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem>Citipower</asp:ListItem>
                                        <asp:ListItem>Powercorp</asp:ListItem>
                                        <asp:ListItem>SP-AusNet</asp:ListItem>
                                        <asp:ListItem>United</asp:ListItem>
                                        <asp:ListItem>Jemena</asp:ListItem>
                                        <asp:ListItem>Endeavour</asp:ListItem>
                                        <asp:ListItem>Ausgrid</asp:ListItem>
                                        <asp:ListItem>Energex</asp:ListItem>
                                        </asp:DropDownList>
                                        <asp:RequiredFieldValidator ID="SelELEC_NETWORK_AREAVali" runat="server" 
                                            ControlToValidate="SelELEC_NETWORK_AREA" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
 

                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox6" runat="server" 
                                        Text='<%# Bind("ELEC_NETWORK_AREA") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Gas Network Area" 
                                SortExpression="GAS_NETWORK_AREA">
                                <ItemTemplate>
                                    <asp:Label ID="Label7" runat="server" Text='<%# Bind("GAS_NETWORK_AREA") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:DropDownList ID="SelGAS_NETWORK_AREA" runat="server" SelectedValue='<%# Bind("GAS_NETWORK_AREA") %>'>
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem>Envestra_Central_1</asp:ListItem>
                                        <asp:ListItem>Envestra_Central_2</asp:ListItem>
                                        <asp:ListItem>Envestra_North</asp:ListItem>
                                        <asp:ListItem>Multinet_1</asp:ListItem>
                                        <asp:ListItem>Multinet_2</asp:ListItem>
                                        <asp:ListItem>SP_AusNet_Central_1</asp:ListItem>
                                        <asp:ListItem>SP_AusNet_Central_2</asp:ListItem>
                                        <asp:ListItem>SP_AusNet_West</asp:ListItem>
                                        <asp:ListItem>Jemena</asp:ListItem>
                                        </asp:DropDownList>
                                        <asp:RequiredFieldValidator ID="SelGAS_NETWORK_AREAVali" runat="server" 
                                            ControlToValidate="SelGAS_NETWORK_AREA" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
 


                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox7" runat="server" 
                                        Text='<%# Bind("GAS_NETWORK_AREA") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Verbal Acceptance Number" 
                                SortExpression="VERBAL_ACCEPTANCE_NO">
                                <ItemTemplate>
                                    <asp:Label ID="Label8" runat="server" 
                                        Text='<%# Bind("VERBAL_ACCEPTANCE_NO") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>

                                    <asp:TextBox ID="VERBAL_ACCEPTANCE_NO" runat="server" Text='<%# Bind("VERBAL_ACCEPTANCE_NO") %>'></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="VERBAL_ACCEPTANCE_NOVali" runat="server" 
                                            ControlToValidate="VERBAL_ACCEPTANCE_NO" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                    <asp:RegularExpressionValidator ID="VERBAL_ACCEPTANCE_NORE" runat="server" 
                                            ErrorMessage="XXXZZZZZZZ9 format(e.g. SSE00000001 XXX:Sale Channel Prefix; ZZZZZZZ9:8 digits)" 
                                            ControlToValidate="VERBAL_ACCEPTANCE_NO" ValidationExpression="^[a-zA-Z]{3}\d{8}"></asp:RegularExpressionValidator>


                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox8" runat="server" 
                                        Text='<%# Bind("VERBAL_ACCEPTANCE_NO") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Company Name" SortExpression="COMPANY_NAME">
                                <ItemTemplate>
                                    <asp:Label ID="Label9" runat="server" Text='<%# Bind("COMPANY_NAME") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="COMPANY_NAME" runat="server" Text='<%# Bind("COMPANY_NAME") %>'></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="COMPANY_NAMEVali" runat="server" 
                                            ControlToValidate="COMPANY_NAME" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox9" runat="server" Text='<%# Bind("COMPANY_NAME") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Title" SortExpression="TITLE">
                                <ItemTemplate>
                                    <asp:Label ID="Label10" runat="server" Text='<%# Bind("TITLE") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:DropDownList ID="SelTITLE" runat="server"
                                        SelectedValue='<%# Bind("TITLE") %>' >
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="Mr">Mr</asp:ListItem>
                                        <asp:ListItem Value="Miss">Miss</asp:ListItem>
                                        <asp:ListItem Value="Mrs">Mrs</asp:ListItem>
                                        <asp:ListItem Value="Ms">Ms</asp:ListItem>
                                        <asp:ListItem Value="Dr">Dr</asp:ListItem>
                                        </asp:DropDownList>
                                    <asp:RequiredFieldValidator ID="SelTITLEVali" runat="server" 
                                            ControlToValidate="SelTITLE" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>


                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox10" runat="server" Text='<%# Bind("TITLE") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*First Name" SortExpression="FIRST_NAME">
                                <ItemTemplate>
                                    <asp:Label ID="Label11" runat="server" Text='<%# Bind("FIRST_NAME") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="FIRST_NAME" runat="server" Text='<%# Bind("FIRST_NAME") %>'></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="FIRST_NAMEVali" runat="server" 
                                            ControlToValidate="FIRST_NAME" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox11" runat="server" Text='<%# Bind("FIRST_NAME") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Last Name" SortExpression="LAST_NAME">
                                <ItemTemplate>
                                    <asp:Label ID="Label12" runat="server" Text='<%# Bind("LAST_NAME") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="LAST_NAME" runat="server" Text='<%# Bind("LAST_NAME") %>'></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="LAST_NAMEVali" runat="server" 
                                            ControlToValidate="LAST_NAME" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox12" runat="server" Text='<%# Bind("LAST_NAME") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Postal Address1" SortExpression="POST_ADDRESS_1">
                                <ItemTemplate>
                                    <asp:Label ID="Label13" runat="server" Text='<%# Bind("POST_ADDRESS_1") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="POST_ADDRESS_1" runat="server" Text='<%# Bind("POST_ADDRESS_1") %>'></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="POST_ADDRESS_1Vali" runat="server" 
                                            ControlToValidate="POST_ADDRESS_1" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox13" runat="server" Text='<%# Bind("POST_ADDRESS_1") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Postal Address2" SortExpression="POST_ADDRESS_2">
                                <ItemTemplate>
                                    <asp:Label ID="Label14" runat="server" Text='<%# Bind("POST_ADDRESS_2") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="TextBox14" runat="server" Text='<%# Bind("POST_ADDRESS_2") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox14" runat="server" Text='<%# Bind("POST_ADDRESS_2") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Postal Address3" SortExpression="POST_ADDRESS_3">
                                <ItemTemplate>
                                    <asp:Label ID="Label15" runat="server" Text='<%# Bind("POST_ADDRESS_3") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="TextBox15" runat="server" Text='<%# Bind("POST_ADDRESS_3") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox15" runat="server" Text='<%# Bind("POST_ADDRESS_3") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Postal Address4" SortExpression="POST_ADDRESS_4">
                                <ItemTemplate>
                                    <asp:Label ID="Label16" runat="server" Text='<%# Bind("POST_ADDRESS_4") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="TextBox16" runat="server" Text='<%# Bind("POST_ADDRESS_4") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox16" runat="server" Text='<%# Bind("POST_ADDRESS_4") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Postal Address Suburb" SortExpression="POST_SUBURB">
                                <ItemTemplate>
                                    <asp:Label ID="Label17" runat="server" Text='<%# Bind("POST_SUBURB") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="POST_SUBURB" runat="server" Text='<%# Bind("POST_SUBURB") %>'></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="POST_SUBURBVali" runat="server" 
                                            ControlToValidate="POST_SUBURB" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox17" runat="server" Text='<%# Bind("POST_SUBURB") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Postal Address State" SortExpression="POST_STATE">
                                <ItemTemplate>
                                    <asp:Label ID="Label18" runat="server" Text='<%# Bind("POST_STATE") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:DropDownList ID="SelPOST_STATE" runat="server"
                                        SelectedValue='<%# Bind("POST_STATE") %>'>
                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem>VIC</asp:ListItem>
                                            <asp:ListItem>NSW</asp:ListItem>
                                            <asp:ListItem>WA</asp:ListItem>
                                            <asp:ListItem>TAS</asp:ListItem>
                                            <asp:ListItem>NT</asp:ListItem>
                                            <asp:ListItem>SA</asp:ListItem>
                                            <asp:ListItem>QLD</asp:ListItem>
                                            <asp:ListItem>ACT</asp:ListItem>
                                        </asp:DropDownList>
                                    <asp:RequiredFieldValidator ID="POST_STATEVali" runat="server" 
                                            ControlToValidate="SelPOST_STATE" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox18" runat="server" Text='<%# Bind("POST_STATE") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Postal Address Postcode" SortExpression="POST_POSTCODE">
                                <ItemTemplate>
                                    <asp:Label ID="Label19" runat="server" Text='<%# Bind("POST_POSTCODE") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="POST_POSTCODE" runat="server" Text='<%# Bind("POST_POSTCODE") %>'></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="POST_POSTCODEVali" runat="server" 
                                            ControlToValidate="POST_POSTCODE" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox19" runat="server" Text='<%# Bind("POST_POSTCODE") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Site Address" SortExpression="SITE_ADD1">
                                <ItemTemplate>
                                    <asp:Label ID="Label20" runat="server" Text='<%# Bind("SITE_ADD1") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="SITE_ADD1" runat="server" Text='<%# Bind("SITE_ADD1") %>'></asp:TextBox>
                                    
                                    <asp:RequiredFieldValidator ID="SITE_ADD1Vali" runat="server" 
                                            ControlToValidate="SITE_ADD1" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                    <input type="button" ID="CopySiteAddress" runat="server" value="Copy Address" onclick="CopySiteAddressClick()"/>

                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox20" runat="server" Text='<%# Bind("SITE_ADD1") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Site Address Suburb" SortExpression="SITE_SUBURB">
                                <ItemTemplate>
                                    <asp:Label ID="Label21" runat="server" Text='<%# Bind("SITE_SUBURB") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="SITE_SUBURB" runat="server" Text='<%# Bind("SITE_SUBURB") %>'></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="SITE_SUBURBVali" runat="server" 
                                            ControlToValidate="SITE_SUBURB" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox21" runat="server" Text='<%# Bind("SITE_SUBURB") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Site Address State" SortExpression="SITE_STATE">
                                <ItemTemplate>
                                    <asp:Label ID="Label22" runat="server" Text='<%# Bind("SITE_STATE") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:DropDownList ID="SelSITE_STATE" runat="server"
                                        SelectedValue='<%# Bind("SITE_STATE") %>'>
                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem>VIC</asp:ListItem>
                                            <asp:ListItem>NSW</asp:ListItem>
                                            <asp:ListItem>WA</asp:ListItem>
                                            <asp:ListItem>TAS</asp:ListItem>
                                            <asp:ListItem>NT</asp:ListItem>
                                            <asp:ListItem>SA</asp:ListItem>
                                            <asp:ListItem>QLD</asp:ListItem>
                                            <asp:ListItem>ACT</asp:ListItem>
                                        </asp:DropDownList>
                                    <asp:RequiredFieldValidator ID="SelSITE_STATEVali" runat="server" 
                                            ControlToValidate="SelSITE_STATE" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                

                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox22" runat="server" Text='<%# Bind("SITE_STATE") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Site Address Postcode" SortExpression="SITE_POSTCODE">
                                <ItemTemplate>
                                    <asp:Label ID="Label23" runat="server" Text='<%# Bind("SITE_POSTCODE") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="SITE_POSTCODE" runat="server" Text='<%# Bind("SITE_POSTCODE") %>'></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="SITE_POSTCODEVali" runat="server" 
                                            ControlToValidate="SITE_POSTCODE" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox23" runat="server" Text='<%# Bind("SITE_POSTCODE") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="EA Account Number" SortExpression="ACCOUNT_ID">
                                <ItemTemplate>
                                    <asp:Label ID="Label24" runat="server" Text='<%# Bind("ACCOUNT_ID") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="TextBox24" runat="server" Text='<%# Bind("ACCOUNT_ID") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox24" runat="server" Text='<%# Bind("ACCOUNT_ID") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="NMI(For Elec Client)" SortExpression="NMI">
                                <ItemTemplate>
                                    <asp:Label ID="Label25" runat="server" Text='<%# Bind("NMI") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="NMI" runat="server" Text='<%# Bind("NMI") %>' onchange="NMIChangedEATRU()"></asp:TextBox>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox25" runat="server" Text='<%# Bind("NMI") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="DPI(For Gas Client)" SortExpression="DPI">
                                <ItemTemplate>
                                    <asp:Label ID="Label26" runat="server" Text='<%# Bind("DPI") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="DPI" runat="server" Text='<%# Bind("DPI") %>' onchange="DPIChangedEATRU()"></asp:TextBox>

                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox26" runat="server" Text='<%# Bind("DPI") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Electricity Discount(%)" SortExpression="ELEC_DISCOUNT">
                                <ItemTemplate>
                                    <asp:Label ID="Label27" runat="server" Text='<%# Bind("ELEC_DISCOUNT") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="ELEC_DISCOUNT" runat="server" Text='<%# Bind("ELEC_DISCOUNT") %>'></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="ELEC_DISCOUNTVali" runat="server" 
                                            ControlToValidate="ELEC_DISCOUNT" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>

                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox27" runat="server" Text='<%# Bind("ELEC_DISCOUNT") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Gas Discount(%)" SortExpression="GAS_DISCOUNT">
                                <ItemTemplate>
                                    <asp:Label ID="Label28" runat="server" Text='<%# Bind("GAS_DISCOUNT") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="GAS_DISCOUNT" runat="server" Text='<%# Bind("GAS_DISCOUNT") %>'></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="GAS_DISCOUNTVali" runat="server" 
                                            ControlToValidate="GAS_DISCOUNT" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>

                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox28" runat="server" Text='<%# Bind("GAS_DISCOUNT") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*One-off Elec Credit Discount($)" SortExpression="ELEC_CREDIT">
                                <ItemTemplate>
                                    <asp:Label ID="Label29" runat="server" Text='<%# Bind("ELEC_CREDIT") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="ELEC_CREDIT" runat="server" Text='<%# Bind("ELEC_CREDIT") %>'></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="ELEC_CREDITVali" runat="server" 
                                            ControlToValidate="ELEC_CREDIT" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>

                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox29" runat="server" Text='<%# Bind("ELEC_CREDIT") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*One-off Gas Credit Discount($)" SortExpression="GAS_CREDIT">
                                <ItemTemplate>
                                    <asp:Label ID="Label30" runat="server" Text='<%# Bind("GAS_CREDIT") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="GAS_CREDIT" runat="server" Text='<%# Bind("GAS_CREDIT") %>'></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="GAS_CREDITVali" runat="server" 
                                            ControlToValidate="GAS_CREDIT" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>

                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox30" runat="server" Text='<%# Bind("GAS_CREDIT") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Green Energy Type" SortExpression="PUREENERGY">
                                <ItemTemplate>
                                    <asp:Label ID="Label31" runat="server" Text='<%# Bind("PUREENERGY") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:DropDownList ID="SelPUREENERGY" runat="server"
                                        SelectedValue='<%# Bind("PUREENERGY") %>'>
                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem>PE10</asp:ListItem>
                                            <asp:ListItem>PE25</asp:ListItem>
                                            <asp:ListItem>PE50</asp:ListItem>
                                            <asp:ListItem>PE100</asp:ListItem>
                                        </asp:DropDownList>
                                    <asp:RequiredFieldValidator ID="SelPUREENERGYVali" runat="server" 
                                            ControlToValidate="SelPUREENERGY" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>
                                
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox31" runat="server" Text='<%# Bind("PUREENERGY") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Date Accepted" SortExpression="DATE_ACCEPTED">
                                <ItemTemplate>
                                    <asp:Label ID="Label32" runat="server" Text='<%# Bind("DATE_ACCEPTED") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="DATE_ACCEPTED" runat="server" onclick="WdatePicker()" 
                                        Text='<%# Bind("DATE_ACCEPTED") %>' ></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="DATE_ACCEPTEDVali" runat="server" 
                                            ControlToValidate="DATE_ACCEPTED" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>

                                
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox32" runat="server" Text='<%# Bind("DATE_ACCEPTED") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Direct Deposit Details Provided?" 
                                SortExpression="DD_DETAILS_GIVEN">
                                <ItemTemplate>
                                    <asp:Label ID="Label33" runat="server" Text='<%# Bind("DD_DETAILS_GIVEN") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:DropDownList ID="SelDD_DETAILS_GIVEN" runat="server"
                                        SelectedValue='<%# Bind("DD_DETAILS_GIVEN") %>'>
                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem>Y</asp:ListItem>
                                            <asp:ListItem>N</asp:ListItem>
                                        </asp:DropDownList>
                                    <asp:RequiredFieldValidator ID="SelDD_DETAILS_GIVENVali" runat="server" 
                                            ControlToValidate="SelDD_DETAILS_GIVEN" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>

                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox33" runat="server" 
                                        Text='<%# Bind("DD_DETAILS_GIVEN") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Method Of Payment" SortExpression="PAYMENT_OPTION">
                                <ItemTemplate>
                                    <asp:Label ID="Label34" runat="server" Text='<%# Bind("PAYMENT_OPTION") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:DropDownList ID="SelPAYMENT_OPTION" runat="server"
                                        SelectedValue='<%# Bind("PAYMENT_OPTION") %>' onchange="SelPAYMENT_OPTIONChanged()">
                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem Value="AUTO">AUTO(Automatic Payment)</asp:ListItem>
                                            <asp:ListItem Value="RPO">RPO(Regular Payment Option)</asp:ListItem>
                                        </asp:DropDownList>
                                    <asp:RequiredFieldValidator ID="SelPAYMENT_OPTIONVali" runat="server" 
                                            ControlToValidate="SelPAYMENT_OPTION" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>

                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox34" runat="server" Text='<%# Bind("PAYMENT_OPTION") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Payment Frequency" 
                                SortExpression="RPO_FREQ_SELECTION">
                                <ItemTemplate>
                                    <asp:Label ID="Label35" runat="server" Text='<%# Bind("RPO_FREQ_SELECTION") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:DropDownList ID="SelRPO_FREQ_SELECTION" runat="server"
                                        SelectedValue='<%# Bind("RPO_FREQ_SELECTION") %>'>
                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem>fortnight</asp:ListItem>
                                            <asp:ListItem>month</asp:ListItem>
                                        </asp:DropDownList>
                                     <asp:RequiredFieldValidator ID="SelRPO_FREQ_SELECTIONVali" runat="server" 
                                            ControlToValidate="SelRPO_FREQ_SELECTION" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>



                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox35" runat="server" 
                                        Text='<%# Bind("RPO_FREQ_SELECTION") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="RPO_ELEC_FORTN" SortExpression="RPO_ELEC_FORTN">
                                <ItemTemplate>
                                    <asp:Label ID="Label36" runat="server" Text='<%# Bind("RPO_ELEC_FORTN") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="TextBox36" runat="server" Text='<%# Bind("RPO_ELEC_FORTN") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox36" runat="server" Text='<%# Bind("RPO_ELEC_FORTN") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="RPO_ELEC_MONTH" SortExpression="RPO_ELEC_MONTH">
                                <ItemTemplate>
                                    <asp:Label ID="Label37" runat="server" Text='<%# Bind("RPO_ELEC_MONTH") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="TextBox37" runat="server" Text='<%# Bind("RPO_ELEC_MONTH") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox37" runat="server" Text='<%# Bind("RPO_ELEC_MONTH") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="RPO_GAS_FORTN" SortExpression="RPO_GAS_FORTN">
                                <ItemTemplate>
                                    <asp:Label ID="Label38" runat="server" Text='<%# Bind("RPO_GAS_FORTN") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="TextBox38" runat="server" Text='<%# Bind("RPO_GAS_FORTN") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox38" runat="server" Text='<%# Bind("RPO_GAS_FORTN") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="RPO_GAS_MONTH" SortExpression="RPO_GAS_MONTH">
                                <ItemTemplate>
                                    <asp:Label ID="Label39" runat="server" Text='<%# Bind("RPO_GAS_MONTH") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="TextBox39" runat="server" Text='<%# Bind("RPO_GAS_MONTH") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox39" runat="server" Text='<%# Bind("RPO_GAS_MONTH") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="RPO_COMB_FORTN" SortExpression="RPO_COMB_FORTN">
                                <ItemTemplate>
                                    <asp:Label ID="Label40" runat="server" Text='<%# Bind("RPO_COMB_FORTN") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="TextBox40" runat="server" Text='<%# Bind("RPO_COMB_FORTN") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox40" runat="server" Text='<%# Bind("RPO_COMB_FORTN") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="RPO_COMB_MONTH" SortExpression="RPO_COMB_MONTH">
                                <ItemTemplate>
                                    <asp:Label ID="Label41" runat="server" Text='<%# Bind("RPO_COMB_MONTH") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="TextBox41" runat="server" Text='<%# Bind("RPO_COMB_MONTH") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox41" runat="server" Text='<%# Bind("RPO_COMB_MONTH") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="RPO_FIRST_PAYMENT_DATE" 
                                SortExpression="RPO_FIRST_PAYMENT_DATE">
                                <ItemTemplate>
                                    <asp:Label ID="Label42" runat="server" 
                                        Text='<%# Bind("RPO_FIRST_PAYMENT_DATE") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="RPO_FIRST_PAYMENT_DATE" runat="server" onclick="WdatePicker()" 
                                        Text='<%# Bind("RPO_FIRST_PAYMENT_DATE") %>' ></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="RPO_FIRST_PAYMENT_DATEVali" runat="server" 
                                            ControlToValidate="RPO_FIRST_PAYMENT_DATE" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>


                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox42" runat="server" 
                                        Text='<%# Bind("RPO_FIRST_PAYMENT_DATE") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Vendor Name" SortExpression="VENDOR_NAME">
                                <ItemTemplate>
                                    <asp:Label ID="Label43" runat="server" Text='<%# Bind("VENDOR_NAME") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="VENDOR_NAME" runat="server" Text='<%# Bind("VENDOR_NAME") %>'></asp:TextBox>

                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox43" runat="server" Text='<%# Bind("VENDOR_NAME") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Vendor Address" SortExpression="VENDOR_ADDRESS">
                                <ItemTemplate>
                                    <asp:Label ID="Label44" runat="server" Text='<%# Bind("VENDOR_ADDRESS") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="VENDOR_ADDRESS" runat="server" Text='<%# Bind("VENDOR_ADDRESS") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox44" runat="server" Text='<%# Bind("VENDOR_ADDRESS") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Vendor Suburb" SortExpression="VENDOR_SUBURB">
                                <ItemTemplate>
                                    <asp:Label ID="Label45" runat="server" Text='<%# Bind("VENDOR_SUBURB") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="VENDOR_SUBURB" runat="server" Text='<%# Bind("VENDOR_SUBURB") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox45" runat="server" Text='<%# Bind("VENDOR_SUBURB") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="VENDOR_STATE" SortExpression="VENDOR_STATE">
                                <ItemTemplate>
                                    <asp:Label ID="Label46" runat="server" Text='<%# Bind("VENDOR_STATE") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:DropDownList ID="SelVENDOR_STATE" runat="server"
                                        SelectedValue='<%# Bind("VENDOR_STATE") %>'>
                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem>VIC</asp:ListItem>
                                            <asp:ListItem>NSW</asp:ListItem>
                                            <asp:ListItem>WA</asp:ListItem>     
                                            <asp:ListItem>TAS</asp:ListItem>
                                            <asp:ListItem>NT</asp:ListItem>
                                            <asp:ListItem>SA</asp:ListItem>
                                            <asp:ListItem>QLD</asp:ListItem>
                                            <asp:ListItem>ACT</asp:ListItem>
                                        </asp:DropDownList>
                                
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox46" runat="server" Text='<%# Bind("VENDOR_STATE") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Vendor Postcode" 
                                SortExpression="VENDOR_POSTCODE">
                                <ItemTemplate>
                                    <asp:Label ID="Label47" runat="server" Text='<%# Bind("VENDOR_POSTCODE") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="VENDOR_POSTCODE" runat="server" 
                                        Text='<%# Bind("VENDOR_POSTCODE") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox47" runat="server" 
                                        Text='<%# Bind("VENDOR_POSTCODE") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Vendor Phone No." SortExpression="VENDOR_PHNO">
                                <ItemTemplate>
                                    <asp:Label ID="Label68" runat="server" Text='<%# Bind("VENDOR_PHNO") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="VENDOR_PHNO" runat="server" Text='<%# Bind("VENDOR_PHNO") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox68" runat="server" Text='<%# Bind("VENDOR_PHNO") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Vendor Fax No." SortExpression="VENDOR_FAXNO">
                                <ItemTemplate>
                                    <asp:Label ID="Label67" runat="server" Text='<%# Bind("VENDOR_FAXNO") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="VENDOR_FAXNO" runat="server" Text='<%# Bind("VENDOR_FAXNO") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox67" runat="server" Text='<%# Bind("VENDOR_FAXNO") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Vendor Email" SortExpression="VENDOR_EMAIL">
                                <ItemTemplate>
                                    <asp:Label ID="Label66" runat="server" Text='<%# Bind("VENDOR_EMAIL") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="VENDOR_EMAIL" runat="server" Text='<%# Bind("VENDOR_EMAIL") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox66" runat="server" Text='<%# Bind("VENDOR_EMAIL") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Payment Type" 
                                SortExpression="PAYMENT_SELECTION">
                                <ItemTemplate>
                                    <asp:Label ID="Label65" runat="server" Text='<%# Bind("PAYMENT_SELECTION") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>

                                    <asp:DropDownList ID="SelPAYMENT_SELECTION" runat="server"
                                        SelectedValue='<%# Bind("PAYMENT_SELECTION") %>'>
                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem Value="D">Debit Card</asp:ListItem>
                                            <asp:ListItem Value="R">RPO</asp:ListItem>
                                        </asp:DropDownList>
                                     <asp:RequiredFieldValidator ID="SelPAYMENT_SELECTIONVali" runat="server" 
                                            ControlToValidate="SelPAYMENT_SELECTION" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>



                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox65" runat="server" 
                                        Text='<%# Bind("PAYMENT_SELECTION") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Campaign Name" SortExpression="CAMPAIGN_NAME">
                                <ItemTemplate>
                                    <asp:Label ID="Label64" runat="server" Text='<%# Bind("CAMPAIGN_NAME") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="CAMPAIGN_NAME" runat="server" Text='<%# Bind("CAMPAIGN_NAME") %>'></asp:TextBox>
                                     <asp:RequiredFieldValidator ID="CAMPAIGN_NAMEVali" runat="server" 
                                            ControlToValidate="CAMPAIGN_NAME" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>

                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox64" runat="server" Text='<%# Bind("CAMPAIGN_NAME") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Campaign Number" 
                                SortExpression="CAMPAIGN_NUMBER">
                                <ItemTemplate>
                                    <asp:Label ID="Label63" runat="server" Text='<%# Bind("CAMPAIGN_NUMBER") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>

                                        <asp:DropDownList ID="SelCAMPAIGN_NUMBER" runat="server" 
                                            SelectedValue='<%# Bind("CAMPAIGN_NUMBER") %>'>
                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem Value="15797">15797</asp:ListItem><asp:ListItem Value="15798">15798</asp:ListItem><asp:ListItem Value="15799">15799</asp:ListItem><asp:ListItem Value="15800">15800</asp:ListItem><asp:ListItem Value="15801">15801</asp:ListItem>
                                        </asp:DropDownList>

                                        <asp:RequiredFieldValidator ID="CAMPAIGN_NUMBERVali" runat="server" 
                                            ControlToValidate="SelCAMPAIGN_NUMBER" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>



                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox63" runat="server" 
                                        Text='<%# Bind("CAMPAIGN_NUMBER") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Campaign Code" SortExpression="CAMPAIGN_CODE">
                                <ItemTemplate>
                                    <asp:Label ID="Label62" runat="server" Text='<%# Bind("CAMPAIGN_CODE") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="CAMPAIGN_CODE" runat="server" Text='<%# Bind("CAMPAIGN_CODE") %>'></asp:TextBox>
                                     <asp:RequiredFieldValidator ID="CAMPAIGN_CODEVali" runat="server" 
                                            ControlToValidate="CAMPAIGN_CODE" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>

                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox62" runat="server" Text='<%# Bind("CAMPAIGN_CODE") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="ABN" SortExpression="ABN">
                                <ItemTemplate>
                                    <asp:Label ID="Label61" runat="server" Text='<%# Bind("ABN") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="ABN" runat="server" Text='<%# Bind("ABN") %>' onchange="ABNChangedEATRU()"></asp:TextBox>
                           
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox61" runat="server" Text='<%# Bind("ABN") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Home Phone" SortExpression="HPHONE">
                                <ItemTemplate>
                                    <asp:Label ID="Label60" runat="server" Text='<%# Bind("HPHONE") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="HPHONE" runat="server" Text='<%# Bind("HPHONE") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox60" runat="server" Text='<%# Bind("HPHONE") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Business Phone" SortExpression="BPHONE">
                                <ItemTemplate>
                                    <asp:Label ID="Label59" runat="server" Text='<%# Bind("BPHONE") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="BPHONE" runat="server" Text='<%# Bind("BPHONE") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox59" runat="server" Text='<%# Bind("BPHONE") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Mobile" SortExpression="MOBILE">
                                <ItemTemplate>
                                    <asp:Label ID="Label58" runat="server" Text='<%# Bind("MOBILE") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="MOBILE" runat="server" Text='<%# Bind("MOBILE") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox58" runat="server" Text='<%# Bind("MOBILE") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Email" SortExpression="EMAIL">
                                <ItemTemplate>
                                    <asp:Label ID="Label57" runat="server" Text='<%# Bind("EMAIL") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="EMAIL" runat="server" Text='<%# Bind("EMAIL") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox57" runat="server" Text='<%# Bind("EMAIL") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Gas Rate" SortExpression="GAS_RATE">
                                <ItemTemplate>
                                    <asp:Label ID="Label56" runat="server" Text='<%# Bind("GAS_RATE") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="GAS_RATE" runat="server" Text='<%# Bind("GAS_RATE") %>'></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="GAS_RATEVali" runat="server" 
                                            ControlToValidate="GAS_RATE" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>

                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox56" runat="server" Text='<%# Bind("GAS_RATE") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Electricity Rate" SortExpression="ELEC_RATE">
                                <ItemTemplate>
                                    <asp:Label ID="Label55" runat="server" Text='<%# Bind("ELEC_RATE") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="ELEC_RATE" runat="server" Text='<%# Bind("ELEC_RATE") %>'></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="ELEC_RATEVali" runat="server" 
                                            ControlToValidate="ELEC_RATE" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>

                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox55" runat="server" Text='<%# Bind("ELEC_RATE") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Current Electricity Provider" 
                                SortExpression="CURRENT_ELECTRICITY_PROVIDER">
                                <ItemTemplate>
                                    <asp:Label ID="Label54" runat="server" 
                                        Text='<%# Bind("CURRENT_ELECTRICITY_PROVIDER") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="CURRENT_ELECTRICITY_PROVIDER" runat="server" 
                                        Text='<%# Bind("CURRENT_ELECTRICITY_PROVIDER") %>'></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="CURRENT_ELECTRICITY_PROVIDERVali" runat="server" 
                                            ControlToValidate="CURRENT_ELECTRICITY_PROVIDER" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>

                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox54" runat="server" 
                                        Text='<%# Bind("CURRENT_ELECTRICITY_PROVIDER") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*Current Gas Provider" 
                                SortExpression="CURRENT_GAS_PROVIDER">
                                <ItemTemplate>
                                    <asp:Label ID="Label53" runat="server" 
                                        Text='<%# Bind("CURRENT_GAS_PROVIDER") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="CURRENT_GAS_PROVIDER" runat="server" 
                                        Text='<%# Bind("CURRENT_GAS_PROVIDER") %>'></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="CURRENT_GAS_PROVIDERVali" runat="server" 
                                            ControlToValidate="CURRENT_GAS_PROVIDER" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>

                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox53" runat="server" 
                                        Text='<%# Bind("CURRENT_GAS_PROVIDER") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Date of Birth" SortExpression="DOB">
                                <ItemTemplate>
                                    <asp:Label ID="Label52" runat="server" Text='<%# Bind("DOB") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="DOB" runat="server" onclick="WdatePicker()"  Text='<%# Bind("DOB") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox52" runat="server" Text='<%# Bind("DOB") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Drivers Licence" 
                                SortExpression="DRIVERS_LICENCE">
                                <ItemTemplate>
                                    <asp:Label ID="Label51" runat="server" Text='<%# Bind("DRIVERS_LICENCE") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="DRIVERS_LICENCE" runat="server" 
                                        Text='<%# Bind("DRIVERS_LICENCE") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox51" runat="server" 
                                        Text='<%# Bind("DRIVERS_LICENCE") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Offer Status" SortExpression="OFFER_STATUS">
                                <ItemTemplate>
                                    <asp:Label ID="Label50" runat="server" Text='<%# Bind("OFFER_STATUS") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                        <asp:DropDownList ID="SelOFFER_STATUS" runat="server"
                                        SelectedValue='<%# Bind("OFFER_STATUS") %>'>
                                            <asp:ListItem Value=""></asp:ListItem>
                                            <asp:ListItem>Verified POS</asp:ListItem>
                                        </asp:DropDownList>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox50" runat="server" Text='<%# Bind("OFFER_STATUS") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="*DPID(Post Delivery Point ID)" SortExpression="DPID">
                                <ItemTemplate>
                                    <asp:Label ID="Label49" runat="server" Text='<%# Bind("DPID") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="DPID" runat="server" Text='<%# Bind("DPID") %>'></asp:TextBox>
                                    <asp:RequiredFieldValidator ID="DPIDVali" runat="server" 
                                            ControlToValidate="DPID" ErrorMessage="*Required Field"></asp:RequiredFieldValidator>

                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox49" runat="server" Text='<%# Bind("DPID") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Mail Type" SortExpression="MAIL_TYPE">
                                <ItemTemplate>
                                    <asp:Label ID="Label48" runat="server" Text='<%# Bind("MAIL_TYPE") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:DropDownList ID="SelMAIL_TYPE" runat="server"
                                        SelectedValue='<%# Bind("MAIL_TYPE") %>'>
                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem>Mail</asp:ListItem>
                                            <asp:ListItem>Email</asp:ListItem>
                                        </asp:DropDownList>
                                
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox48" runat="server" Text='<%# Bind("MAIL_TYPE") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Selected Offer" 
                                SortExpression="OFFER_SELECTION">
                                <ItemTemplate>
                                    <asp:Label ID="Label69" runat="server" Text='<%# Bind("OFFER_SELECTION") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                        <asp:DropDownList ID="SelOFFER_SELECTION" runat="server" 
                                            SelectedValue='<%# Bind("OFFER_SELECTION") %>'>
                                            <asp:ListItem Value="">Select...</asp:ListItem>
                                            <asp:ListItem Value="SSE_QLD T11_8% + $75 2Y">SSE_QLD T11_8% + $75 2Y</asp:ListItem><asp:ListItem Value="SSE_QLD T11_8% PE10% + $75 2Y">SSE_QLD T11_8% PE10% + $75 2Y</asp:ListItem><asp:ListItem Value="SSE_QLD T11_8% PE25% + $75 2Y">SSE_QLD T11_8% PE25% + $75 2Y</asp:ListItem><asp:ListItem Value="SSE_QLD T11_8% PE50% + $75 2Y">SSE_QLD T11_8% PE50% + $75 2Y</asp:ListItem><asp:ListItem Value="SSE_QLD T11_8% PE100% + $75 2Y">SSE_QLD T11_8% PE100% + $75 2Y</asp:ListItem>
                                       </asp:DropDownList>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox ID="TextBox69" runat="server" 
                                        Text='<%# Bind("OFFER_SELECTION") %>'></asp:TextBox>
                                </InsertItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField ShowHeader="False">
                                <ItemTemplate>
                                    <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" 
                                        CommandName="Edit" Text="Edit"></asp:LinkButton>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="True" 
                                        CommandName="Update" Text="Update"></asp:LinkButton>
                                    &nbsp;<asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" 
                                        CommandName="Cancel" Text="Cancel"></asp:LinkButton>
                                </EditItemTemplate>
                            </asp:TemplateField>
                    </Fields>
                        <PagerStyle CssClass="pgr" />
                </asp:DetailsView>

                <asp:SqlDataSource ID="SqlDataSource4" runat="server" 
                    ConflictDetection="CompareAllValues" 
                    ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>" 
                    DeleteCommand="DELETE FROM [EA_TRU] WHERE [ID] = @original_ID AND (([USERID] = @original_USERID) OR ([USERID] IS NULL AND @original_USERID IS NULL)) AND (([FUEL_TYPE] = @original_FUEL_TYPE) OR ([FUEL_TYPE] IS NULL AND @original_FUEL_TYPE IS NULL)) AND (([DISCOUNT_TYPE] = @original_DISCOUNT_TYPE) OR ([DISCOUNT_TYPE] IS NULL AND @original_DISCOUNT_TYPE IS NULL)) AND (([CUSTOMER_TYPE] = @original_CUSTOMER_TYPE) OR ([CUSTOMER_TYPE] IS NULL AND @original_CUSTOMER_TYPE IS NULL)) AND (([CONTRACT_DURATION] = @original_CONTRACT_DURATION) OR ([CONTRACT_DURATION] IS NULL AND @original_CONTRACT_DURATION IS NULL)) AND (([ELEC_NETWORK_AREA] = @original_ELEC_NETWORK_AREA) OR ([ELEC_NETWORK_AREA] IS NULL AND @original_ELEC_NETWORK_AREA IS NULL)) AND (([GAS_NETWORK_AREA] = @original_GAS_NETWORK_AREA) OR ([GAS_NETWORK_AREA] IS NULL AND @original_GAS_NETWORK_AREA IS NULL)) AND (([VERBAL_ACCEPTANCE_NO] = @original_VERBAL_ACCEPTANCE_NO) OR ([VERBAL_ACCEPTANCE_NO] IS NULL AND @original_VERBAL_ACCEPTANCE_NO IS NULL)) AND (([COMPANY_NAME] = @original_COMPANY_NAME) OR ([COMPANY_NAME] IS NULL AND @original_COMPANY_NAME IS NULL)) AND (([TITLE] = @original_TITLE) OR ([TITLE] IS NULL AND @original_TITLE IS NULL)) AND (([FIRST_NAME] = @original_FIRST_NAME) OR ([FIRST_NAME] IS NULL AND @original_FIRST_NAME IS NULL)) AND (([LAST_NAME] = @original_LAST_NAME) OR ([LAST_NAME] IS NULL AND @original_LAST_NAME IS NULL)) AND (([POST_ADDRESS_1] = @original_POST_ADDRESS_1) OR ([POST_ADDRESS_1] IS NULL AND @original_POST_ADDRESS_1 IS NULL)) AND (([POST_ADDRESS_2] = @original_POST_ADDRESS_2) OR ([POST_ADDRESS_2] IS NULL AND @original_POST_ADDRESS_2 IS NULL)) AND (([POST_ADDRESS_3] = @original_POST_ADDRESS_3) OR ([POST_ADDRESS_3] IS NULL AND @original_POST_ADDRESS_3 IS NULL)) AND (([POST_ADDRESS_4] = @original_POST_ADDRESS_4) OR ([POST_ADDRESS_4] IS NULL AND @original_POST_ADDRESS_4 IS NULL)) AND (([POST_SUBURB] = @original_POST_SUBURB) OR ([POST_SUBURB] IS NULL AND @original_POST_SUBURB IS NULL)) AND (([POST_STATE] = @original_POST_STATE) OR ([POST_STATE] IS NULL AND @original_POST_STATE IS NULL)) AND (([POST_POSTCODE] = @original_POST_POSTCODE) OR ([POST_POSTCODE] IS NULL AND @original_POST_POSTCODE IS NULL)) AND (([SITE_ADD1] = @original_SITE_ADD1) OR ([SITE_ADD1] IS NULL AND @original_SITE_ADD1 IS NULL)) AND (([SITE_SUBURB] = @original_SITE_SUBURB) OR ([SITE_SUBURB] IS NULL AND @original_SITE_SUBURB IS NULL)) AND (([SITE_STATE] = @original_SITE_STATE) OR ([SITE_STATE] IS NULL AND @original_SITE_STATE IS NULL)) AND (([SITE_POSTCODE] = @original_SITE_POSTCODE) OR ([SITE_POSTCODE] IS NULL AND @original_SITE_POSTCODE IS NULL)) AND (([ACCOUNT_ID] = @original_ACCOUNT_ID) OR ([ACCOUNT_ID] IS NULL AND @original_ACCOUNT_ID IS NULL)) AND (([NMI] = @original_NMI) OR ([NMI] IS NULL AND @original_NMI IS NULL)) AND (([DPI] = @original_DPI) OR ([DPI] IS NULL AND @original_DPI IS NULL)) AND (([ELEC_DISCOUNT] = @original_ELEC_DISCOUNT) OR ([ELEC_DISCOUNT] IS NULL AND @original_ELEC_DISCOUNT IS NULL)) AND (([GAS_DISCOUNT] = @original_GAS_DISCOUNT) OR ([GAS_DISCOUNT] IS NULL AND @original_GAS_DISCOUNT IS NULL)) AND (([ELEC_CREDIT] = @original_ELEC_CREDIT) OR ([ELEC_CREDIT] IS NULL AND @original_ELEC_CREDIT IS NULL)) AND (([GAS_CREDIT] = @original_GAS_CREDIT) OR ([GAS_CREDIT] IS NULL AND @original_GAS_CREDIT IS NULL)) AND (([PUREENERGY] = @original_PUREENERGY) OR ([PUREENERGY] IS NULL AND @original_PUREENERGY IS NULL)) AND (([DATE_ACCEPTED] = @original_DATE_ACCEPTED) OR ([DATE_ACCEPTED] IS NULL AND @original_DATE_ACCEPTED IS NULL)) AND (([DD_DETAILS_GIVEN] = @original_DD_DETAILS_GIVEN) OR ([DD_DETAILS_GIVEN] IS NULL AND @original_DD_DETAILS_GIVEN IS NULL)) AND (([PAYMENT_OPTION] = @original_PAYMENT_OPTION) OR ([PAYMENT_OPTION] IS NULL AND @original_PAYMENT_OPTION IS NULL)) AND (([RPO_FREQ_SELECTION] = @original_RPO_FREQ_SELECTION) OR ([RPO_FREQ_SELECTION] IS NULL AND @original_RPO_FREQ_SELECTION IS NULL)) AND (([RPO_ELEC_FORTN] = @original_RPO_ELEC_FORTN) OR ([RPO_ELEC_FORTN] IS NULL AND @original_RPO_ELEC_FORTN IS NULL)) AND (([RPO_ELEC_MONTH] = @original_RPO_ELEC_MONTH) OR ([RPO_ELEC_MONTH] IS NULL AND @original_RPO_ELEC_MONTH IS NULL)) AND (([RPO_GAS_FORTN] = @original_RPO_GAS_FORTN) OR ([RPO_GAS_FORTN] IS NULL AND @original_RPO_GAS_FORTN IS NULL)) AND (([RPO_GAS_MONTH] = @original_RPO_GAS_MONTH) OR ([RPO_GAS_MONTH] IS NULL AND @original_RPO_GAS_MONTH IS NULL)) AND (([RPO_COMB_FORTN] = @original_RPO_COMB_FORTN) OR ([RPO_COMB_FORTN] IS NULL AND @original_RPO_COMB_FORTN IS NULL)) AND (([RPO_COMB_MONTH] = @original_RPO_COMB_MONTH) OR ([RPO_COMB_MONTH] IS NULL AND @original_RPO_COMB_MONTH IS NULL)) AND (([RPO_FIRST_PAYMENT_DATE] = @original_RPO_FIRST_PAYMENT_DATE) OR ([RPO_FIRST_PAYMENT_DATE] IS NULL AND @original_RPO_FIRST_PAYMENT_DATE IS NULL)) AND (([VENDOR_NAME] = @original_VENDOR_NAME) OR ([VENDOR_NAME] IS NULL AND @original_VENDOR_NAME IS NULL)) AND (([VENDOR_ADDRESS] = @original_VENDOR_ADDRESS) OR ([VENDOR_ADDRESS] IS NULL AND @original_VENDOR_ADDRESS IS NULL)) AND (([VENDOR_SUBURB] = @original_VENDOR_SUBURB) OR ([VENDOR_SUBURB] IS NULL AND @original_VENDOR_SUBURB IS NULL)) AND (([VENDOR_STATE] = @original_VENDOR_STATE) OR ([VENDOR_STATE] IS NULL AND @original_VENDOR_STATE IS NULL)) AND (([VENDOR_POSTCODE] = @original_VENDOR_POSTCODE) OR ([VENDOR_POSTCODE] IS NULL AND @original_VENDOR_POSTCODE IS NULL)) AND (([VENDOR_PHNO] = @original_VENDOR_PHNO) OR ([VENDOR_PHNO] IS NULL AND @original_VENDOR_PHNO IS NULL)) AND (([VENDOR_FAXNO] = @original_VENDOR_FAXNO) OR ([VENDOR_FAXNO] IS NULL AND @original_VENDOR_FAXNO IS NULL)) AND (([VENDOR_EMAIL] = @original_VENDOR_EMAIL) OR ([VENDOR_EMAIL] IS NULL AND @original_VENDOR_EMAIL IS NULL)) AND (([PAYMENT_SELECTION] = @original_PAYMENT_SELECTION) OR ([PAYMENT_SELECTION] IS NULL AND @original_PAYMENT_SELECTION IS NULL)) AND (([CAMPAIGN_NAME] = @original_CAMPAIGN_NAME) OR ([CAMPAIGN_NAME] IS NULL AND @original_CAMPAIGN_NAME IS NULL)) AND (([CAMPAIGN_NUMBER] = @original_CAMPAIGN_NUMBER) OR ([CAMPAIGN_NUMBER] IS NULL AND @original_CAMPAIGN_NUMBER IS NULL)) AND (([CAMPAIGN_CODE] = @original_CAMPAIGN_CODE) OR ([CAMPAIGN_CODE] IS NULL AND @original_CAMPAIGN_CODE IS NULL)) AND (([ABN] = @original_ABN) OR ([ABN] IS NULL AND @original_ABN IS NULL)) AND (([HPHONE] = @original_HPHONE) OR ([HPHONE] IS NULL AND @original_HPHONE IS NULL)) AND (([BPHONE] = @original_BPHONE) OR ([BPHONE] IS NULL AND @original_BPHONE IS NULL)) AND (([MOBILE] = @original_MOBILE) OR ([MOBILE] IS NULL AND @original_MOBILE IS NULL)) AND (([EMAIL] = @original_EMAIL) OR ([EMAIL] IS NULL AND @original_EMAIL IS NULL)) AND (([GAS_RATE] = @original_GAS_RATE) OR ([GAS_RATE] IS NULL AND @original_GAS_RATE IS NULL)) AND (([ELEC_RATE] = @original_ELEC_RATE) OR ([ELEC_RATE] IS NULL AND @original_ELEC_RATE IS NULL)) AND (([CURRENT_ELECTRICITY_PROVIDER] = @original_CURRENT_ELECTRICITY_PROVIDER) OR ([CURRENT_ELECTRICITY_PROVIDER] IS NULL AND @original_CURRENT_ELECTRICITY_PROVIDER IS NULL)) AND (([CURRENT_GAS_PROVIDER] = @original_CURRENT_GAS_PROVIDER) OR ([CURRENT_GAS_PROVIDER] IS NULL AND @original_CURRENT_GAS_PROVIDER IS NULL)) AND (([DOB] = @original_DOB) OR ([DOB] IS NULL AND @original_DOB IS NULL)) AND (([DRIVERS_LICENCE] = @original_DRIVERS_LICENCE) OR ([DRIVERS_LICENCE] IS NULL AND @original_DRIVERS_LICENCE IS NULL)) AND (([OFFER_STATUS] = @original_OFFER_STATUS) OR ([OFFER_STATUS] IS NULL AND @original_OFFER_STATUS IS NULL)) AND (([DPID] = @original_DPID) OR ([DPID] IS NULL AND @original_DPID IS NULL)) AND (([MAIL_TYPE] = @original_MAIL_TYPE) OR ([MAIL_TYPE] IS NULL AND @original_MAIL_TYPE IS NULL)) AND (([OFFER_SELECTION] = @original_OFFER_SELECTION) OR ([OFFER_SELECTION] IS NULL AND @original_OFFER_SELECTION IS NULL))" 
                    InsertCommand="INSERT INTO [EA_TRU] ([USERID], [FUEL_TYPE], [DISCOUNT_TYPE], [CUSTOMER_TYPE], [CONTRACT_DURATION], [ELEC_NETWORK_AREA], [GAS_NETWORK_AREA], [VERBAL_ACCEPTANCE_NO], [COMPANY_NAME], [TITLE], [FIRST_NAME], [LAST_NAME], [POST_ADDRESS_1], [POST_ADDRESS_2], [POST_ADDRESS_3], [POST_ADDRESS_4], [POST_SUBURB], [POST_STATE], [POST_POSTCODE], [SITE_ADD1], [SITE_SUBURB], [SITE_STATE], [SITE_POSTCODE], [ACCOUNT_ID], [NMI], [DPI], [ELEC_DISCOUNT], [GAS_DISCOUNT], [ELEC_CREDIT], [GAS_CREDIT], [PUREENERGY], [DATE_ACCEPTED], [DD_DETAILS_GIVEN], [PAYMENT_OPTION], [RPO_FREQ_SELECTION], [RPO_ELEC_FORTN], [RPO_ELEC_MONTH], [RPO_GAS_FORTN], [RPO_GAS_MONTH], [RPO_COMB_FORTN], [RPO_COMB_MONTH], [RPO_FIRST_PAYMENT_DATE], [VENDOR_NAME], [VENDOR_ADDRESS], [VENDOR_SUBURB], [VENDOR_STATE], [VENDOR_POSTCODE], [VENDOR_PHNO], [VENDOR_FAXNO], [VENDOR_EMAIL], [PAYMENT_SELECTION], [CAMPAIGN_NAME], [CAMPAIGN_NUMBER], [CAMPAIGN_CODE], [ABN], [HPHONE], [BPHONE], [MOBILE], [EMAIL], [GAS_RATE], [ELEC_RATE], [CURRENT_ELECTRICITY_PROVIDER], [CURRENT_GAS_PROVIDER], [DOB], [DRIVERS_LICENCE], [OFFER_STATUS], [DPID], [MAIL_TYPE], [OFFER_SELECTION]) VALUES (@USERID, @FUEL_TYPE, @DISCOUNT_TYPE, @CUSTOMER_TYPE, @CONTRACT_DURATION, @ELEC_NETWORK_AREA, @GAS_NETWORK_AREA, @VERBAL_ACCEPTANCE_NO, @COMPANY_NAME, @TITLE, @FIRST_NAME, @LAST_NAME, @POST_ADDRESS_1, @POST_ADDRESS_2, @POST_ADDRESS_3, @POST_ADDRESS_4, @POST_SUBURB, @POST_STATE, @POST_POSTCODE, @SITE_ADD1, @SITE_SUBURB, @SITE_STATE, @SITE_POSTCODE, @ACCOUNT_ID, @NMI, @DPI, @ELEC_DISCOUNT, @GAS_DISCOUNT, @ELEC_CREDIT, @GAS_CREDIT, @PUREENERGY, @DATE_ACCEPTED, @DD_DETAILS_GIVEN, @PAYMENT_OPTION, @RPO_FREQ_SELECTION, @RPO_ELEC_FORTN, @RPO_ELEC_MONTH, @RPO_GAS_FORTN, @RPO_GAS_MONTH, @RPO_COMB_FORTN, @RPO_COMB_MONTH, @RPO_FIRST_PAYMENT_DATE, @VENDOR_NAME, @VENDOR_ADDRESS, @VENDOR_SUBURB, @VENDOR_STATE, @VENDOR_POSTCODE, @VENDOR_PHNO, @VENDOR_FAXNO, @VENDOR_EMAIL, @PAYMENT_SELECTION, @CAMPAIGN_NAME, @CAMPAIGN_NUMBER, @CAMPAIGN_CODE, @ABN, @HPHONE, @BPHONE, @MOBILE, @EMAIL, @GAS_RATE, @ELEC_RATE, @CURRENT_ELECTRICITY_PROVIDER, @CURRENT_GAS_PROVIDER, @DOB, @DRIVERS_LICENCE, @OFFER_STATUS, @DPID, @MAIL_TYPE, @OFFER_SELECTION)" 
                    OldValuesParameterFormatString="original_{0}" 
                    SelectCommand="SELECT * FROM [EA_TRU] WHERE ([USERID] = @USERID)" 
                    UpdateCommand="UPDATE [EA_TRU] SET [USERID] = @USERID, [FUEL_TYPE] = @FUEL_TYPE, [DISCOUNT_TYPE] = @DISCOUNT_TYPE, [CUSTOMER_TYPE] = @CUSTOMER_TYPE, [CONTRACT_DURATION] = @CONTRACT_DURATION, [ELEC_NETWORK_AREA] = @ELEC_NETWORK_AREA, [GAS_NETWORK_AREA] = @GAS_NETWORK_AREA, [VERBAL_ACCEPTANCE_NO] = @VERBAL_ACCEPTANCE_NO, [COMPANY_NAME] = @COMPANY_NAME, [TITLE] = @TITLE, [FIRST_NAME] = @FIRST_NAME, [LAST_NAME] = @LAST_NAME, [POST_ADDRESS_1] = @POST_ADDRESS_1, [POST_ADDRESS_2] = @POST_ADDRESS_2, [POST_ADDRESS_3] = @POST_ADDRESS_3, [POST_ADDRESS_4] = @POST_ADDRESS_4, [POST_SUBURB] = @POST_SUBURB, [POST_STATE] = @POST_STATE, [POST_POSTCODE] = @POST_POSTCODE, [SITE_ADD1] = @SITE_ADD1, [SITE_SUBURB] = @SITE_SUBURB, [SITE_STATE] = @SITE_STATE, [SITE_POSTCODE] = @SITE_POSTCODE, [ACCOUNT_ID] = @ACCOUNT_ID, [NMI] = @NMI, [DPI] = @DPI, [ELEC_DISCOUNT] = @ELEC_DISCOUNT, [GAS_DISCOUNT] = @GAS_DISCOUNT, [ELEC_CREDIT] = @ELEC_CREDIT, [GAS_CREDIT] = @GAS_CREDIT, [PUREENERGY] = @PUREENERGY, [DATE_ACCEPTED] = @DATE_ACCEPTED, [DD_DETAILS_GIVEN] = @DD_DETAILS_GIVEN, [PAYMENT_OPTION] = @PAYMENT_OPTION, [RPO_FREQ_SELECTION] = @RPO_FREQ_SELECTION, [RPO_ELEC_FORTN] = @RPO_ELEC_FORTN, [RPO_ELEC_MONTH] = @RPO_ELEC_MONTH, [RPO_GAS_FORTN] = @RPO_GAS_FORTN, [RPO_GAS_MONTH] = @RPO_GAS_MONTH, [RPO_COMB_FORTN] = @RPO_COMB_FORTN, [RPO_COMB_MONTH] = @RPO_COMB_MONTH, [RPO_FIRST_PAYMENT_DATE] = @RPO_FIRST_PAYMENT_DATE, [VENDOR_NAME] = @VENDOR_NAME, [VENDOR_ADDRESS] = @VENDOR_ADDRESS, [VENDOR_SUBURB] = @VENDOR_SUBURB, [VENDOR_STATE] = @VENDOR_STATE, [VENDOR_POSTCODE] = @VENDOR_POSTCODE, [VENDOR_PHNO] = @VENDOR_PHNO, [VENDOR_FAXNO] = @VENDOR_FAXNO, [VENDOR_EMAIL] = @VENDOR_EMAIL, [PAYMENT_SELECTION] = @PAYMENT_SELECTION, [CAMPAIGN_NAME] = @CAMPAIGN_NAME, [CAMPAIGN_NUMBER] = @CAMPAIGN_NUMBER, [CAMPAIGN_CODE] = @CAMPAIGN_CODE, [ABN] = @ABN, [HPHONE] = @HPHONE, [BPHONE] = @BPHONE, [MOBILE] = @MOBILE, [EMAIL] = @EMAIL, [GAS_RATE] = @GAS_RATE, [ELEC_RATE] = @ELEC_RATE, [CURRENT_ELECTRICITY_PROVIDER] = @CURRENT_ELECTRICITY_PROVIDER, [CURRENT_GAS_PROVIDER] = @CURRENT_GAS_PROVIDER, [DOB] = @DOB, [DRIVERS_LICENCE] = @DRIVERS_LICENCE, [OFFER_STATUS] = @OFFER_STATUS, [DPID] = @DPID, [MAIL_TYPE] = @MAIL_TYPE, [OFFER_SELECTION] = @OFFER_SELECTION WHERE [ID] = @original_ID AND (([USERID] = @original_USERID) OR ([USERID] IS NULL AND @original_USERID IS NULL)) AND (([FUEL_TYPE] = @original_FUEL_TYPE) OR ([FUEL_TYPE] IS NULL AND @original_FUEL_TYPE IS NULL)) AND (([DISCOUNT_TYPE] = @original_DISCOUNT_TYPE) OR ([DISCOUNT_TYPE] IS NULL AND @original_DISCOUNT_TYPE IS NULL)) AND (([CUSTOMER_TYPE] = @original_CUSTOMER_TYPE) OR ([CUSTOMER_TYPE] IS NULL AND @original_CUSTOMER_TYPE IS NULL)) AND (([CONTRACT_DURATION] = @original_CONTRACT_DURATION) OR ([CONTRACT_DURATION] IS NULL AND @original_CONTRACT_DURATION IS NULL)) AND (([ELEC_NETWORK_AREA] = @original_ELEC_NETWORK_AREA) OR ([ELEC_NETWORK_AREA] IS NULL AND @original_ELEC_NETWORK_AREA IS NULL)) AND (([GAS_NETWORK_AREA] = @original_GAS_NETWORK_AREA) OR ([GAS_NETWORK_AREA] IS NULL AND @original_GAS_NETWORK_AREA IS NULL)) AND (([VERBAL_ACCEPTANCE_NO] = @original_VERBAL_ACCEPTANCE_NO) OR ([VERBAL_ACCEPTANCE_NO] IS NULL AND @original_VERBAL_ACCEPTANCE_NO IS NULL)) AND (([COMPANY_NAME] = @original_COMPANY_NAME) OR ([COMPANY_NAME] IS NULL AND @original_COMPANY_NAME IS NULL)) AND (([TITLE] = @original_TITLE) OR ([TITLE] IS NULL AND @original_TITLE IS NULL)) AND (([FIRST_NAME] = @original_FIRST_NAME) OR ([FIRST_NAME] IS NULL AND @original_FIRST_NAME IS NULL)) AND (([LAST_NAME] = @original_LAST_NAME) OR ([LAST_NAME] IS NULL AND @original_LAST_NAME IS NULL)) AND (([POST_ADDRESS_1] = @original_POST_ADDRESS_1) OR ([POST_ADDRESS_1] IS NULL AND @original_POST_ADDRESS_1 IS NULL)) AND (([POST_ADDRESS_2] = @original_POST_ADDRESS_2) OR ([POST_ADDRESS_2] IS NULL AND @original_POST_ADDRESS_2 IS NULL)) AND (([POST_ADDRESS_3] = @original_POST_ADDRESS_3) OR ([POST_ADDRESS_3] IS NULL AND @original_POST_ADDRESS_3 IS NULL)) AND (([POST_ADDRESS_4] = @original_POST_ADDRESS_4) OR ([POST_ADDRESS_4] IS NULL AND @original_POST_ADDRESS_4 IS NULL)) AND (([POST_SUBURB] = @original_POST_SUBURB) OR ([POST_SUBURB] IS NULL AND @original_POST_SUBURB IS NULL)) AND (([POST_STATE] = @original_POST_STATE) OR ([POST_STATE] IS NULL AND @original_POST_STATE IS NULL)) AND (([POST_POSTCODE] = @original_POST_POSTCODE) OR ([POST_POSTCODE] IS NULL AND @original_POST_POSTCODE IS NULL)) AND (([SITE_ADD1] = @original_SITE_ADD1) OR ([SITE_ADD1] IS NULL AND @original_SITE_ADD1 IS NULL)) AND (([SITE_SUBURB] = @original_SITE_SUBURB) OR ([SITE_SUBURB] IS NULL AND @original_SITE_SUBURB IS NULL)) AND (([SITE_STATE] = @original_SITE_STATE) OR ([SITE_STATE] IS NULL AND @original_SITE_STATE IS NULL)) AND (([SITE_POSTCODE] = @original_SITE_POSTCODE) OR ([SITE_POSTCODE] IS NULL AND @original_SITE_POSTCODE IS NULL)) AND (([ACCOUNT_ID] = @original_ACCOUNT_ID) OR ([ACCOUNT_ID] IS NULL AND @original_ACCOUNT_ID IS NULL)) AND (([NMI] = @original_NMI) OR ([NMI] IS NULL AND @original_NMI IS NULL)) AND (([DPI] = @original_DPI) OR ([DPI] IS NULL AND @original_DPI IS NULL)) AND (([ELEC_DISCOUNT] = @original_ELEC_DISCOUNT) OR ([ELEC_DISCOUNT] IS NULL AND @original_ELEC_DISCOUNT IS NULL)) AND (([GAS_DISCOUNT] = @original_GAS_DISCOUNT) OR ([GAS_DISCOUNT] IS NULL AND @original_GAS_DISCOUNT IS NULL)) AND (([ELEC_CREDIT] = @original_ELEC_CREDIT) OR ([ELEC_CREDIT] IS NULL AND @original_ELEC_CREDIT IS NULL)) AND (([GAS_CREDIT] = @original_GAS_CREDIT) OR ([GAS_CREDIT] IS NULL AND @original_GAS_CREDIT IS NULL)) AND (([PUREENERGY] = @original_PUREENERGY) OR ([PUREENERGY] IS NULL AND @original_PUREENERGY IS NULL)) AND (([DATE_ACCEPTED] = @original_DATE_ACCEPTED) OR ([DATE_ACCEPTED] IS NULL AND @original_DATE_ACCEPTED IS NULL)) AND (([DD_DETAILS_GIVEN] = @original_DD_DETAILS_GIVEN) OR ([DD_DETAILS_GIVEN] IS NULL AND @original_DD_DETAILS_GIVEN IS NULL)) AND (([PAYMENT_OPTION] = @original_PAYMENT_OPTION) OR ([PAYMENT_OPTION] IS NULL AND @original_PAYMENT_OPTION IS NULL)) AND (([RPO_FREQ_SELECTION] = @original_RPO_FREQ_SELECTION) OR ([RPO_FREQ_SELECTION] IS NULL AND @original_RPO_FREQ_SELECTION IS NULL)) AND (([RPO_ELEC_FORTN] = @original_RPO_ELEC_FORTN) OR ([RPO_ELEC_FORTN] IS NULL AND @original_RPO_ELEC_FORTN IS NULL)) AND (([RPO_ELEC_MONTH] = @original_RPO_ELEC_MONTH) OR ([RPO_ELEC_MONTH] IS NULL AND @original_RPO_ELEC_MONTH IS NULL)) AND (([RPO_GAS_FORTN] = @original_RPO_GAS_FORTN) OR ([RPO_GAS_FORTN] IS NULL AND @original_RPO_GAS_FORTN IS NULL)) AND (([RPO_GAS_MONTH] = @original_RPO_GAS_MONTH) OR ([RPO_GAS_MONTH] IS NULL AND @original_RPO_GAS_MONTH IS NULL)) AND (([RPO_COMB_FORTN] = @original_RPO_COMB_FORTN) OR ([RPO_COMB_FORTN] IS NULL AND @original_RPO_COMB_FORTN IS NULL)) AND (([RPO_COMB_MONTH] = @original_RPO_COMB_MONTH) OR ([RPO_COMB_MONTH] IS NULL AND @original_RPO_COMB_MONTH IS NULL)) AND (([RPO_FIRST_PAYMENT_DATE] = @original_RPO_FIRST_PAYMENT_DATE) OR ([RPO_FIRST_PAYMENT_DATE] IS NULL AND @original_RPO_FIRST_PAYMENT_DATE IS NULL)) AND (([VENDOR_NAME] = @original_VENDOR_NAME) OR ([VENDOR_NAME] IS NULL AND @original_VENDOR_NAME IS NULL)) AND (([VENDOR_ADDRESS] = @original_VENDOR_ADDRESS) OR ([VENDOR_ADDRESS] IS NULL AND @original_VENDOR_ADDRESS IS NULL)) AND (([VENDOR_SUBURB] = @original_VENDOR_SUBURB) OR ([VENDOR_SUBURB] IS NULL AND @original_VENDOR_SUBURB IS NULL)) AND (([VENDOR_STATE] = @original_VENDOR_STATE) OR ([VENDOR_STATE] IS NULL AND @original_VENDOR_STATE IS NULL)) AND (([VENDOR_POSTCODE] = @original_VENDOR_POSTCODE) OR ([VENDOR_POSTCODE] IS NULL AND @original_VENDOR_POSTCODE IS NULL)) AND (([VENDOR_PHNO] = @original_VENDOR_PHNO) OR ([VENDOR_PHNO] IS NULL AND @original_VENDOR_PHNO IS NULL)) AND (([VENDOR_FAXNO] = @original_VENDOR_FAXNO) OR ([VENDOR_FAXNO] IS NULL AND @original_VENDOR_FAXNO IS NULL)) AND (([VENDOR_EMAIL] = @original_VENDOR_EMAIL) OR ([VENDOR_EMAIL] IS NULL AND @original_VENDOR_EMAIL IS NULL)) AND (([PAYMENT_SELECTION] = @original_PAYMENT_SELECTION) OR ([PAYMENT_SELECTION] IS NULL AND @original_PAYMENT_SELECTION IS NULL)) AND (([CAMPAIGN_NAME] = @original_CAMPAIGN_NAME) OR ([CAMPAIGN_NAME] IS NULL AND @original_CAMPAIGN_NAME IS NULL)) AND (([CAMPAIGN_NUMBER] = @original_CAMPAIGN_NUMBER) OR ([CAMPAIGN_NUMBER] IS NULL AND @original_CAMPAIGN_NUMBER IS NULL)) AND (([CAMPAIGN_CODE] = @original_CAMPAIGN_CODE) OR ([CAMPAIGN_CODE] IS NULL AND @original_CAMPAIGN_CODE IS NULL)) AND (([ABN] = @original_ABN) OR ([ABN] IS NULL AND @original_ABN IS NULL)) AND (([HPHONE] = @original_HPHONE) OR ([HPHONE] IS NULL AND @original_HPHONE IS NULL)) AND (([BPHONE] = @original_BPHONE) OR ([BPHONE] IS NULL AND @original_BPHONE IS NULL)) AND (([MOBILE] = @original_MOBILE) OR ([MOBILE] IS NULL AND @original_MOBILE IS NULL)) AND (([EMAIL] = @original_EMAIL) OR ([EMAIL] IS NULL AND @original_EMAIL IS NULL)) AND (([GAS_RATE] = @original_GAS_RATE) OR ([GAS_RATE] IS NULL AND @original_GAS_RATE IS NULL)) AND (([ELEC_RATE] = @original_ELEC_RATE) OR ([ELEC_RATE] IS NULL AND @original_ELEC_RATE IS NULL)) AND (([CURRENT_ELECTRICITY_PROVIDER] = @original_CURRENT_ELECTRICITY_PROVIDER) OR ([CURRENT_ELECTRICITY_PROVIDER] IS NULL AND @original_CURRENT_ELECTRICITY_PROVIDER IS NULL)) AND (([CURRENT_GAS_PROVIDER] = @original_CURRENT_GAS_PROVIDER) OR ([CURRENT_GAS_PROVIDER] IS NULL AND @original_CURRENT_GAS_PROVIDER IS NULL)) AND (([DOB] = @original_DOB) OR ([DOB] IS NULL AND @original_DOB IS NULL)) AND (([DRIVERS_LICENCE] = @original_DRIVERS_LICENCE) OR ([DRIVERS_LICENCE] IS NULL AND @original_DRIVERS_LICENCE IS NULL)) AND (([OFFER_STATUS] = @original_OFFER_STATUS) OR ([OFFER_STATUS] IS NULL AND @original_OFFER_STATUS IS NULL)) AND (([DPID] = @original_DPID) OR ([DPID] IS NULL AND @original_DPID IS NULL)) AND (([MAIL_TYPE] = @original_MAIL_TYPE) OR ([MAIL_TYPE] IS NULL AND @original_MAIL_TYPE IS NULL)) AND (([OFFER_SELECTION] = @original_OFFER_SELECTION) OR ([OFFER_SELECTION] IS NULL AND @original_OFFER_SELECTION IS NULL))">
                <DeleteParameters>
                    <asp:Parameter Name="original_ID" Type="Int32" />
                    <asp:Parameter Name="original_USERID" Type="Int32" />
                    <asp:Parameter Name="original_FUEL_TYPE" Type="String" />
                    <asp:Parameter Name="original_DISCOUNT_TYPE" Type="String" />
                    <asp:Parameter Name="original_CUSTOMER_TYPE" Type="String" />
                    <asp:Parameter Name="original_CONTRACT_DURATION" Type="String" />
                    <asp:Parameter Name="original_ELEC_NETWORK_AREA" Type="String" />
                    <asp:Parameter Name="original_GAS_NETWORK_AREA" Type="String" />
                    <asp:Parameter Name="original_VERBAL_ACCEPTANCE_NO" Type="String" />
                    <asp:Parameter Name="original_COMPANY_NAME" Type="String" />
                    <asp:Parameter Name="original_TITLE" Type="String" />
                    <asp:Parameter Name="original_FIRST_NAME" Type="String" />
                    <asp:Parameter Name="original_LAST_NAME" Type="String" />
                    <asp:Parameter Name="original_POST_ADDRESS_1" Type="String" />
                    <asp:Parameter Name="original_POST_ADDRESS_2" Type="String" />
                    <asp:Parameter Name="original_POST_ADDRESS_3" Type="String" />
                    <asp:Parameter Name="original_POST_ADDRESS_4" Type="String" />
                    <asp:Parameter Name="original_POST_SUBURB" Type="String" />
                    <asp:Parameter Name="original_POST_STATE" Type="String" />
                    <asp:Parameter Name="original_POST_POSTCODE" Type="String" />
                    <asp:Parameter Name="original_SITE_ADD1" Type="String" />
                    <asp:Parameter Name="original_SITE_SUBURB" Type="String" />
                    <asp:Parameter Name="original_SITE_STATE" Type="String" />
                    <asp:Parameter Name="original_SITE_POSTCODE" Type="String" />
                    <asp:Parameter Name="original_ACCOUNT_ID" Type="String" />
                    <asp:Parameter Name="original_NMI" Type="String" />
                    <asp:Parameter Name="original_DPI" Type="String" />
                    <asp:Parameter Name="original_ELEC_DISCOUNT" Type="String" />
                    <asp:Parameter Name="original_GAS_DISCOUNT" Type="String" />
                    <asp:Parameter Name="original_ELEC_CREDIT" Type="String" />
                    <asp:Parameter Name="original_GAS_CREDIT" Type="String" />
                    <asp:Parameter Name="original_PUREENERGY" Type="String" />
                    <asp:Parameter Name="original_DATE_ACCEPTED" Type="String" />
                    <asp:Parameter Name="original_DD_DETAILS_GIVEN" Type="String" />
                    <asp:Parameter Name="original_PAYMENT_OPTION" Type="String" />
                    <asp:Parameter Name="original_RPO_FREQ_SELECTION" Type="String" />
                    <asp:Parameter Name="original_RPO_ELEC_FORTN" Type="String" />
                    <asp:Parameter Name="original_RPO_ELEC_MONTH" Type="String" />
                    <asp:Parameter Name="original_RPO_GAS_FORTN" Type="String" />
                    <asp:Parameter Name="original_RPO_GAS_MONTH" Type="String" />
                    <asp:Parameter Name="original_RPO_COMB_FORTN" Type="String" />
                    <asp:Parameter Name="original_RPO_COMB_MONTH" Type="String" />
                    <asp:Parameter Name="original_RPO_FIRST_PAYMENT_DATE" Type="String" />
                    <asp:Parameter Name="original_VENDOR_NAME" Type="String" />
                    <asp:Parameter Name="original_VENDOR_ADDRESS" Type="String" />
                    <asp:Parameter Name="original_VENDOR_SUBURB" Type="String" />
                    <asp:Parameter Name="original_VENDOR_STATE" Type="String" />
                    <asp:Parameter Name="original_VENDOR_POSTCODE" Type="String" />
                    <asp:Parameter Name="original_VENDOR_PHNO" Type="String" />
                    <asp:Parameter Name="original_VENDOR_FAXNO" Type="String" />
                    <asp:Parameter Name="original_VENDOR_EMAIL" Type="String" />
                    <asp:Parameter Name="original_PAYMENT_SELECTION" Type="String" />
                    <asp:Parameter Name="original_CAMPAIGN_NAME" Type="String" />
                    <asp:Parameter Name="original_CAMPAIGN_NUMBER" Type="String" />
                    <asp:Parameter Name="original_CAMPAIGN_CODE" Type="String" />
                    <asp:Parameter Name="original_ABN" Type="String" />
                    <asp:Parameter Name="original_HPHONE" Type="String" />
                    <asp:Parameter Name="original_BPHONE" Type="String" />
                    <asp:Parameter Name="original_MOBILE" Type="String" />
                    <asp:Parameter Name="original_EMAIL" Type="String" />
                    <asp:Parameter Name="original_GAS_RATE" Type="String" />
                    <asp:Parameter Name="original_ELEC_RATE" Type="String" />
                    <asp:Parameter Name="original_CURRENT_ELECTRICITY_PROVIDER" Type="String" />
                    <asp:Parameter Name="original_CURRENT_GAS_PROVIDER" Type="String" />
                    <asp:Parameter Name="original_DOB" Type="String" />
                    <asp:Parameter Name="original_DRIVERS_LICENCE" Type="String" />
                    <asp:Parameter Name="original_OFFER_STATUS" Type="String" />
                    <asp:Parameter Name="original_DPID" Type="String" />
                    <asp:Parameter Name="original_MAIL_TYPE" Type="String" />
                    <asp:Parameter Name="original_OFFER_SELECTION" Type="String" />
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="USERID" Type="Int32" />
                    <asp:Parameter Name="FUEL_TYPE" Type="String" />
                    <asp:Parameter Name="DISCOUNT_TYPE" Type="String" />
                    <asp:Parameter Name="CUSTOMER_TYPE" Type="String" />
                    <asp:Parameter Name="CONTRACT_DURATION" Type="String" />
                    <asp:Parameter Name="ELEC_NETWORK_AREA" Type="String" />
                    <asp:Parameter Name="GAS_NETWORK_AREA" Type="String" />
                    <asp:Parameter Name="VERBAL_ACCEPTANCE_NO" Type="String" />
                    <asp:Parameter Name="COMPANY_NAME" Type="String" />
                    <asp:Parameter Name="TITLE" Type="String" />
                    <asp:Parameter Name="FIRST_NAME" Type="String" />
                    <asp:Parameter Name="LAST_NAME" Type="String" />
                    <asp:Parameter Name="POST_ADDRESS_1" Type="String" />
                    <asp:Parameter Name="POST_ADDRESS_2" Type="String" />
                    <asp:Parameter Name="POST_ADDRESS_3" Type="String" />
                    <asp:Parameter Name="POST_ADDRESS_4" Type="String" />
                    <asp:Parameter Name="POST_SUBURB" Type="String" />
                    <asp:Parameter Name="POST_STATE" Type="String" />
                    <asp:Parameter Name="POST_POSTCODE" Type="String" />
                    <asp:Parameter Name="SITE_ADD1" Type="String" />
                    <asp:Parameter Name="SITE_SUBURB" Type="String" />
                    <asp:Parameter Name="SITE_STATE" Type="String" />
                    <asp:Parameter Name="SITE_POSTCODE" Type="String" />
                    <asp:Parameter Name="ACCOUNT_ID" Type="String" />
                    <asp:Parameter Name="NMI" Type="String" />
                    <asp:Parameter Name="DPI" Type="String" />
                    <asp:Parameter Name="ELEC_DISCOUNT" Type="String" />
                    <asp:Parameter Name="GAS_DISCOUNT" Type="String" />
                    <asp:Parameter Name="ELEC_CREDIT" Type="String" />
                    <asp:Parameter Name="GAS_CREDIT" Type="String" />
                    <asp:Parameter Name="PUREENERGY" Type="String" />
                    <asp:Parameter Name="DATE_ACCEPTED" Type="String" />
                    <asp:Parameter Name="DD_DETAILS_GIVEN" Type="String" />
                    <asp:Parameter Name="PAYMENT_OPTION" Type="String" />
                    <asp:Parameter Name="RPO_FREQ_SELECTION" Type="String" />
                    <asp:Parameter Name="RPO_ELEC_FORTN" Type="String" />
                    <asp:Parameter Name="RPO_ELEC_MONTH" Type="String" />
                    <asp:Parameter Name="RPO_GAS_FORTN" Type="String" />
                    <asp:Parameter Name="RPO_GAS_MONTH" Type="String" />
                    <asp:Parameter Name="RPO_COMB_FORTN" Type="String" />
                    <asp:Parameter Name="RPO_COMB_MONTH" Type="String" />
                    <asp:Parameter Name="RPO_FIRST_PAYMENT_DATE" Type="String" />
                    <asp:Parameter Name="VENDOR_NAME" Type="String" />
                    <asp:Parameter Name="VENDOR_ADDRESS" Type="String" />
                    <asp:Parameter Name="VENDOR_SUBURB" Type="String" />
                    <asp:Parameter Name="VENDOR_STATE" Type="String" />
                    <asp:Parameter Name="VENDOR_POSTCODE" Type="String" />
                    <asp:Parameter Name="VENDOR_PHNO" Type="String" />
                    <asp:Parameter Name="VENDOR_FAXNO" Type="String" />
                    <asp:Parameter Name="VENDOR_EMAIL" Type="String" />
                    <asp:Parameter Name="PAYMENT_SELECTION" Type="String" />
                    <asp:Parameter Name="CAMPAIGN_NAME" Type="String" />
                    <asp:Parameter Name="CAMPAIGN_NUMBER" Type="String" />
                    <asp:Parameter Name="CAMPAIGN_CODE" Type="String" />
                    <asp:Parameter Name="ABN" Type="String" />
                    <asp:Parameter Name="HPHONE" Type="String" />
                    <asp:Parameter Name="BPHONE" Type="String" />
                    <asp:Parameter Name="MOBILE" Type="String" />
                    <asp:Parameter Name="EMAIL" Type="String" />
                    <asp:Parameter Name="GAS_RATE" Type="String" />
                    <asp:Parameter Name="ELEC_RATE" Type="String" />
                    <asp:Parameter Name="CURRENT_ELECTRICITY_PROVIDER" Type="String" />
                    <asp:Parameter Name="CURRENT_GAS_PROVIDER" Type="String" />
                    <asp:Parameter Name="DOB" Type="String" />
                    <asp:Parameter Name="DRIVERS_LICENCE" Type="String" />
                    <asp:Parameter Name="OFFER_STATUS" Type="String" />
                    <asp:Parameter Name="DPID" Type="String" />
                    <asp:Parameter Name="MAIL_TYPE" Type="String" />
                    <asp:Parameter Name="OFFER_SELECTION" Type="String" />
                </InsertParameters>
                <SelectParameters>
                    <asp:ControlParameter ControlID="GridView1" Name="USERID" 
                        PropertyName="SelectedValue" Type="Int32" />
                </SelectParameters>
                <UpdateParameters>
                    <asp:Parameter Name="USERID" Type="Int32" />
                    <asp:Parameter Name="FUEL_TYPE" Type="String" />
                    <asp:Parameter Name="DISCOUNT_TYPE" Type="String" />
                    <asp:Parameter Name="CUSTOMER_TYPE" Type="String" />
                    <asp:Parameter Name="CONTRACT_DURATION" Type="String" />
                    <asp:Parameter Name="ELEC_NETWORK_AREA" Type="String" />
                    <asp:Parameter Name="GAS_NETWORK_AREA" Type="String" />
                    <asp:Parameter Name="VERBAL_ACCEPTANCE_NO" Type="String" />
                    <asp:Parameter Name="COMPANY_NAME" Type="String" />
                    <asp:Parameter Name="TITLE" Type="String" />
                    <asp:Parameter Name="FIRST_NAME" Type="String" />
                    <asp:Parameter Name="LAST_NAME" Type="String" />
                    <asp:Parameter Name="POST_ADDRESS_1" Type="String" />
                    <asp:Parameter Name="POST_ADDRESS_2" Type="String" />
                    <asp:Parameter Name="POST_ADDRESS_3" Type="String" />
                    <asp:Parameter Name="POST_ADDRESS_4" Type="String" />
                    <asp:Parameter Name="POST_SUBURB" Type="String" />
                    <asp:Parameter Name="POST_STATE" Type="String" />
                    <asp:Parameter Name="POST_POSTCODE" Type="String" />
                    <asp:Parameter Name="SITE_ADD1" Type="String" />
                    <asp:Parameter Name="SITE_SUBURB" Type="String" />
                    <asp:Parameter Name="SITE_STATE" Type="String" />
                    <asp:Parameter Name="SITE_POSTCODE" Type="String" />
                    <asp:Parameter Name="ACCOUNT_ID" Type="String" />
                    <asp:Parameter Name="NMI" Type="String" />
                    <asp:Parameter Name="DPI" Type="String" />
                    <asp:Parameter Name="ELEC_DISCOUNT" Type="String" />
                    <asp:Parameter Name="GAS_DISCOUNT" Type="String" />
                    <asp:Parameter Name="ELEC_CREDIT" Type="String" />
                    <asp:Parameter Name="GAS_CREDIT" Type="String" />
                    <asp:Parameter Name="PUREENERGY" Type="String" />
                    <asp:Parameter Name="DATE_ACCEPTED" Type="String" />
                    <asp:Parameter Name="DD_DETAILS_GIVEN" Type="String" />
                    <asp:Parameter Name="PAYMENT_OPTION" Type="String" />
                    <asp:Parameter Name="RPO_FREQ_SELECTION" Type="String" />
                    <asp:Parameter Name="RPO_ELEC_FORTN" Type="String" />
                    <asp:Parameter Name="RPO_ELEC_MONTH" Type="String" />
                    <asp:Parameter Name="RPO_GAS_FORTN" Type="String" />
                    <asp:Parameter Name="RPO_GAS_MONTH" Type="String" />
                    <asp:Parameter Name="RPO_COMB_FORTN" Type="String" />
                    <asp:Parameter Name="RPO_COMB_MONTH" Type="String" />
                    <asp:Parameter Name="RPO_FIRST_PAYMENT_DATE" Type="String" />
                    <asp:Parameter Name="VENDOR_NAME" Type="String" />
                    <asp:Parameter Name="VENDOR_ADDRESS" Type="String" />
                    <asp:Parameter Name="VENDOR_SUBURB" Type="String" />
                    <asp:Parameter Name="VENDOR_STATE" Type="String" />
                    <asp:Parameter Name="VENDOR_POSTCODE" Type="String" />
                    <asp:Parameter Name="VENDOR_PHNO" Type="String" />
                    <asp:Parameter Name="VENDOR_FAXNO" Type="String" />
                    <asp:Parameter Name="VENDOR_EMAIL" Type="String" />
                    <asp:Parameter Name="PAYMENT_SELECTION" Type="String" />
                    <asp:Parameter Name="CAMPAIGN_NAME" Type="String" />
                    <asp:Parameter Name="CAMPAIGN_NUMBER" Type="String" />
                    <asp:Parameter Name="CAMPAIGN_CODE" Type="String" />
                    <asp:Parameter Name="ABN" Type="String" />
                    <asp:Parameter Name="HPHONE" Type="String" />
                    <asp:Parameter Name="BPHONE" Type="String" />
                    <asp:Parameter Name="MOBILE" Type="String" />
                    <asp:Parameter Name="EMAIL" Type="String" />
                    <asp:Parameter Name="GAS_RATE" Type="String" />
                    <asp:Parameter Name="ELEC_RATE" Type="String" />
                    <asp:Parameter Name="CURRENT_ELECTRICITY_PROVIDER" Type="String" />
                    <asp:Parameter Name="CURRENT_GAS_PROVIDER" Type="String" />
                    <asp:Parameter Name="DOB" Type="String" />
                    <asp:Parameter Name="DRIVERS_LICENCE" Type="String" />
                    <asp:Parameter Name="OFFER_STATUS" Type="String" />
                    <asp:Parameter Name="DPID" Type="String" />
                    <asp:Parameter Name="MAIL_TYPE" Type="String" />
                    <asp:Parameter Name="OFFER_SELECTION" Type="String" />
                    <asp:Parameter Name="original_ID" Type="Int32" />
                    <asp:Parameter Name="original_USERID" Type="Int32" />
                    <asp:Parameter Name="original_FUEL_TYPE" Type="String" />
                    <asp:Parameter Name="original_DISCOUNT_TYPE" Type="String" />
                    <asp:Parameter Name="original_CUSTOMER_TYPE" Type="String" />
                    <asp:Parameter Name="original_CONTRACT_DURATION" Type="String" />
                    <asp:Parameter Name="original_ELEC_NETWORK_AREA" Type="String" />
                    <asp:Parameter Name="original_GAS_NETWORK_AREA" Type="String" />
                    <asp:Parameter Name="original_VERBAL_ACCEPTANCE_NO" Type="String" />
                    <asp:Parameter Name="original_COMPANY_NAME" Type="String" />
                    <asp:Parameter Name="original_TITLE" Type="String" />
                    <asp:Parameter Name="original_FIRST_NAME" Type="String" />
                    <asp:Parameter Name="original_LAST_NAME" Type="String" />
                    <asp:Parameter Name="original_POST_ADDRESS_1" Type="String" />
                    <asp:Parameter Name="original_POST_ADDRESS_2" Type="String" />
                    <asp:Parameter Name="original_POST_ADDRESS_3" Type="String" />
                    <asp:Parameter Name="original_POST_ADDRESS_4" Type="String" />
                    <asp:Parameter Name="original_POST_SUBURB" Type="String" />
                    <asp:Parameter Name="original_POST_STATE" Type="String" />
                    <asp:Parameter Name="original_POST_POSTCODE" Type="String" />
                    <asp:Parameter Name="original_SITE_ADD1" Type="String" />
                    <asp:Parameter Name="original_SITE_SUBURB" Type="String" />
                    <asp:Parameter Name="original_SITE_STATE" Type="String" />
                    <asp:Parameter Name="original_SITE_POSTCODE" Type="String" />
                    <asp:Parameter Name="original_ACCOUNT_ID" Type="String" />
                    <asp:Parameter Name="original_NMI" Type="String" />
                    <asp:Parameter Name="original_DPI" Type="String" />
                    <asp:Parameter Name="original_ELEC_DISCOUNT" Type="String" />
                    <asp:Parameter Name="original_GAS_DISCOUNT" Type="String" />
                    <asp:Parameter Name="original_ELEC_CREDIT" Type="String" />
                    <asp:Parameter Name="original_GAS_CREDIT" Type="String" />
                    <asp:Parameter Name="original_PUREENERGY" Type="String" />
                    <asp:Parameter Name="original_DATE_ACCEPTED" Type="String" />
                    <asp:Parameter Name="original_DD_DETAILS_GIVEN" Type="String" />
                    <asp:Parameter Name="original_PAYMENT_OPTION" Type="String" />
                    <asp:Parameter Name="original_RPO_FREQ_SELECTION" Type="String" />
                    <asp:Parameter Name="original_RPO_ELEC_FORTN" Type="String" />
                    <asp:Parameter Name="original_RPO_ELEC_MONTH" Type="String" />
                    <asp:Parameter Name="original_RPO_GAS_FORTN" Type="String" />
                    <asp:Parameter Name="original_RPO_GAS_MONTH" Type="String" />
                    <asp:Parameter Name="original_RPO_COMB_FORTN" Type="String" />
                    <asp:Parameter Name="original_RPO_COMB_MONTH" Type="String" />
                    <asp:Parameter Name="original_RPO_FIRST_PAYMENT_DATE" Type="String" />
                    <asp:Parameter Name="original_VENDOR_NAME" Type="String" />
                    <asp:Parameter Name="original_VENDOR_ADDRESS" Type="String" />
                    <asp:Parameter Name="original_VENDOR_SUBURB" Type="String" />
                    <asp:Parameter Name="original_VENDOR_STATE" Type="String" />
                    <asp:Parameter Name="original_VENDOR_POSTCODE" Type="String" />
                    <asp:Parameter Name="original_VENDOR_PHNO" Type="String" />
                    <asp:Parameter Name="original_VENDOR_FAXNO" Type="String" />
                    <asp:Parameter Name="original_VENDOR_EMAIL" Type="String" />
                    <asp:Parameter Name="original_PAYMENT_SELECTION" Type="String" />
                    <asp:Parameter Name="original_CAMPAIGN_NAME" Type="String" />
                    <asp:Parameter Name="original_CAMPAIGN_NUMBER" Type="String" />
                    <asp:Parameter Name="original_CAMPAIGN_CODE" Type="String" />
                    <asp:Parameter Name="original_ABN" Type="String" />
                    <asp:Parameter Name="original_HPHONE" Type="String" />
                    <asp:Parameter Name="original_BPHONE" Type="String" />
                    <asp:Parameter Name="original_MOBILE" Type="String" />
                    <asp:Parameter Name="original_EMAIL" Type="String" />
                    <asp:Parameter Name="original_GAS_RATE" Type="String" />
                    <asp:Parameter Name="original_ELEC_RATE" Type="String" />
                    <asp:Parameter Name="original_CURRENT_ELECTRICITY_PROVIDER" Type="String" />
                    <asp:Parameter Name="original_CURRENT_GAS_PROVIDER" Type="String" />
                    <asp:Parameter Name="original_DOB" Type="String" />
                    <asp:Parameter Name="original_DRIVERS_LICENCE" Type="String" />
                    <asp:Parameter Name="original_OFFER_STATUS" Type="String" />
                    <asp:Parameter Name="original_DPID" Type="String" />
                    <asp:Parameter Name="original_MAIL_TYPE" Type="String" />
                    <asp:Parameter Name="original_OFFER_SELECTION" Type="String" />
                </UpdateParameters>
                </asp:SqlDataSource>